Home > Answers > How to Highlight or Remove Duplicates in Excel 2007 twa1320311909

How to Highlight or Remove Duplicates in Excel 2007?

I have an Excel file with 20K records. How do I select all entries with repeated records and then remove only the duplicated ones?

Answers (1)

Joseal

For Excel 2007, this is pretty easy. Just go to the Data menu and then select Remove Duplicates from the Data Tools section on the top quick access toolbar.

05:56, 4 November 2011

Arutelude loomiseks tuleb sisse logida.

Seotud terminid

Intuit
Software; Software development

Intuit Inc. is an American software company that develops ...

GasBuddy
Software; Phone apps

Gas prices can be a major headache, but with GasBuddy, you ...

Viggle
Software; Phone apps

An app that awards you for watching TV?! Viggle lets users ...

Total Recall
Software; Email

Total Recall is an email feature that allows messages sent ...

expand
Software; Operating systems

To display the subentries contained within a folder or ...

EPAM Systems
Software; Software engineering

EPAM Systems is a global provider of software engineering ...

Looja

Featured blossaries

English Quotes

Kategooria: Arts   2 1 Terms

Real-Property

Kategooria: Business   1 1 Terms

EMA, SmPC and PIL terms in EN, FI

Kategooria: Science   2 4 Terms

Most Widely Spoken Languages in the World 2014

Kategooria: Languages   2 10 Terms

Boeing Company

Kategooria: Technology   2 20 Terms

Xiaomi

Kategooria: Technology   1 7 Terms

TermWiki is ranked top innovative application by IDC.

© 2024 CSOFT International, Ltd.   

Jälgige meid: